home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
powerb5.zip
/
P5SPR000.TIP
< prev
next >
Wrap
Text File
|
1993-06-01
|
2KB
|
45 lines
I'm a college teacher, and use Quattro Pro to do my record
keeping. Because I prefer to enter and read grades as
letters (for example, B+) but need a numerical equivalent to
compute averages, I wanted a formula to convert a letter
grade to its corresponding number. The task was complicated
by the fact that D and F are consecutive grades but are
separated by a letter alphabetically.
When I build a spreadsheet to hold class records, I put the
alphabetic grades from each assignment or exam in one
column. In another column, I type the formula
(69 - @CODE(address)+@ABS(69-@CODE(address)))/2+
@IF(@MID(address,1,1) = "+",.3,(@IF(@MID(address,1,1)="-",-.3, 0)))
where "address" is the cell address containing the letter
grade. The result of this formula is the grade converted to
a number. I then average the converted grades and show grade
point averages next to the block of letter grades.
Lewis D. Blake III
Durham, North Carolina
Editor's Note: The formula is broken into two lines here for
readability, but you should type all of it into a single
cell in your spreadsheet. Mr. Blake happens to be a Quattro
user, but you don't need Quattro to use this technique.
Reflex, 1-2-3, and many other programs have identical @ABS,
@CODE, and @MID functions and can use this formula with few
or no changes.
But be warned: The macro is case sensitive. The letter
grades must be entered as capital letters. Also, this
formula will give you an absurd result for characters
outside the A-to-F range and will return an error if the
cell to be converted is empty.
Title: Making the Grade
Category: SPR
Issue Date: January, 1992
Editor: Brett Glass
Supplementary Files: None
Filename: P5SPR000.TIP